EXCEL® SHORTCUT KEYS
F2 Edit the selected cell
F5 Go to a specific cell
F7 Spell check selected text
and/or document
F11 Create chart
Ctrl + Shift + ; Enter the
current time
Ctrl + ; Enter the current
date
Alt + Shift + F1 Insert new
worksheet
Shift + F3 Open the Excel®
formula window
Shift + F5 Bring up search
box
Ctrl + A Select all contents
of worksheet
Ctrl + B Bold highlighted
selection
Ctrl + I Italicize
highlighted selection
Ctrl + C Copy selected text
Ctrl + V Paste
Ctrl + D Fill
Ctrl + K Insert link
Ctrl + F Open find and
replace options
Ctrl + G Open go-to options
Ctrl + H Open find and
replace options
Ctrl + U Underline
highlighted selection
Ctrl + Y Underline selected
text
Ctrl + 5 Strikethrough
highlighted selection
Ctrl + O Open options
Ctrl + N Open new document
Ctrl + P Open print dialog
box
Ctrl + S Save
Ctrl + Z Undo last action
Ctrl + F9 Minimize current
window
Ctrl + F10 Maximize currently
selected window
Ctrl + F6 Switch between open workbooks/windows
Ctrl + Page up & Page Down Move between Excel® worksheets in the same document
Ctrl + Tab Move between two
or more open Excel® files
Alt + = Create formula to sum
all of above cells
Ctrl + ‘ Insert value of
above cell into current cell
Ctrl + Shift + ! Format
number in comma format
Ctrl + Shift + $ Format
number in currency format
Ctrl + Shift + # Format
number in date format
Ctrl + Shift + % Format
number in percentage format
Ctrl + Shift + ^ Format
number in scientific format
Ctrl + Shift + @ Format
number in time format
Ctrl + g Move to next section
of text
Ctrl + Space Select entire
column
Shift + Space Select entire
row
Ctrl + W Close document
0 Comments: